Move and copy data

When you copy or cut a cell and then paste it, you copy or move the entire cell, including formulas and their resulting values, and cell formats.

If the area you select to copy includes cells hidden by filtering, you copy only the visible cells. You cannot move data from a range that includes filtered rows. To move the data you must first turn off filtering.

1. In the design window, make sure the spreadsheet is activated. For instructions, see Help for your design program.
2. Select the cells you want to move or copy.
3. Do one of the following:

   • To move the cells, click Cut .

   • To copy the cells, click Copy .

   Note  When you cut data, you can paste it only once, but if you copy data, you can paste it multiple times. If you want to paste the data in several locations, use the Copy button to copy the data.

4. Click the upper-left cell of the area where you want to paste the cells.
5. Click Paste .

Notes

• Cells that you copy or move replace any data in the area where you paste the cells.
• When you move a formula, the cell references within the formula do not change. When you copy a formula, absolute cell references do not change; however, relative cell references will change.

1. In the design window, make sure the spreadsheet is activated. For instructions, see Help for your design program.
2. Double-click the cell with the characters you want to move or copy.
3. In the cell, select the characters you want to move or copy.
4. Do one of the following:

   • To move the characters, click Cut .

   • To copy the characters, click Copy .

5. In the cell, click where you want to paste the characters.
6. Click Paste .
7. Press ENTER.

Note  When you move or copy characters from within one cell to another cell, the moved or copied characters take on the formatting of the destination cell.